odate;
$customer = $data->customer;
// $menus = $data->menus;
// $items = $data->items;
// $qty = $data->qty;
//$ucost = $data->ucost;
$orderno = $data->orderno;
$sel = $DBcon->prepare("select * from ordertemp where order_id = '$orderno'") ;
$sel->execute() ;
$count = 0 ;
//GET TOTAL SUM
$tsum = $DBcon->prepare("select sum(totalcost) as amt from ordertemp where order_id = '$orderno'") ;
$tsum->execute() ;
$trow = $tsum->fetch(pdo::FETCH_ASSOC) ;
$amto = $trow["amt"] ;
?>
| SN |
ITEMS |
QUANTITY |
UNIT-COST |
TOTAL |
ACTION |
fetch(pdo::FETCH_ASSOC) )
{
$count++ ;
echo "" ;
echo "| ".$count." | " ;
echo "".$row['item']." | " ;
echo "".$row['quantity']." | " ;
echo "".$row['unitcost']." | " ;
$tcost = $row['quantity'] * $row['unitcost'] ;
?>
|
Del |
" ;
}
?>
| |
|
|
Grand Total |
|
|